﻿/****** Object:  Index [PK_Picture]    Script Date: 05/30/2013 22:39:12 ******/
ALTER TABLE [dbo].[Picture] DROP CONSTRAINT [PK_Picture]
GO
CREATE CLUSTERED INDEX [picture_takePhotoDate] ON [dbo].[Picture] 
(
	[TakePhotoDate] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

CREATE UNIQUE NONCLUSTERED INDEX [PK_Picture] ON [dbo].[Picture] 
(
	[PictureId] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

